SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104366 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104366 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352897,204931,599361,797414,344200,848835,538019,451289,810322,377558,444297,222813,420788,802562,501191,200986,51332,500617,475357,277743,718055,160537,75783,149361,683321,250809,939113,417316,270927,32040,983923,803503,936343,275516,1048691,1000982,275288,872838,652435,266293,333553,725428,433581,558886,974190,826744,430667,911458,840609,394636,828205,14361,204962,319657,4505,658426,327483,59276,83975,692120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001847s ]