SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519140 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519140 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9283,25182,153915,336991,117621,383182,686297,729156,626447,232393,752314,834506,4063,745709,600742,173553,137306,592215,882958,729849,519354,953527,381077,337094,961355,185391,793674,1011682,596140,915770,509011,789952,169590,99105,542808,48213,585976,196099,912970,544743,535298,206307,941101,620542,700172,891381,749139,903020,1015363,395079,5949,927734,509619,857715,1019899,22462,368937,445369,12134,707378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]