SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531273 LIMIT 1 [ RunTime:0.000806s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531273 [ RunTime:0.007058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593440,219474,1016102,124870,553178,192978,68202,516734,1418,652638,785116,453910,894038,212886,501004,755471,691505,250871,690188,612518,699832,456133,141729,326519,785298,937643,984026,23099,145013,397691,615661,173568,346943,839205,1023350,518465,1006635,169876,946560,805260,108445,391764,609715,911418,855550,425798,13415,186256,21520,98057,932528,582085,70168,805017,474132,871887,549807,14611,41733,144057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001235s ]