SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023783 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023783 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569778,599022,838805,454246,761703,128893,760874,123166,6218,841904,828591,508848,842638,595557,789383,835349,442755,754037,80342,43325,576596,431261,342968,514078,749395,461958,311709,348543,77807,469154,698445,170785,95733,908217,378527,567475,591754,475055,244907,44590,895145,798740,857114,630026,120936,342141,884018,752386,686697,755802,861717,449806,247934,471303,916996,59616,1014793,289933,613392,1033489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023783 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023783 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001387s ]