SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515231 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515231 [ RunTime:0.006088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853771,168500,296900,928881,1006931,660783,143989,927374,340553,864103,537801,617932,740047,767586,371347,273980,489346,513725,477978,188971,844871,873020,310358,752009,341706,1006118,169564,741319,992868,824029,323266,451400,465137,301892,218195,836958,512044,980634,230234,691530,791377,913682,515515,894276,603023,886250,591383,195755,394606,749351,477627,543840,293510,505510,808493,564952,128730,267397,137587,712581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]