SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001729s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54100 LIMIT 1 [ RunTime:0.000756s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54100 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117657,625558,637120,1038097,150549,776982,345358,972695,74809,717188,485019,481469,607884,565257,917821,405326,80939,954261,432230,893526,718997,446941,392659,500616,801255,807939,746424,20546,355864,365297,27834,676932,180214,692717,695759,724995,8285,15640,744521,871041,962040,543231,513430,336523,237846,488184,422394,522489,227695,326265,207107,988567,385499,700713,82742,710966,707555,134006,835036,763519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]