SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861096 LIMIT 1 [ RunTime:0.001358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861096 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295110,1033763,19763,83836,57795,579053,749615,396558,911155,494763,903728,754719,375218,128782,346079,267553,1048445,862620,1046207,221918,433773,20240,792531,269976,357512,369003,771038,37194,399298,114731,449889,179766,873845,782045,217878,544319,694116,1043155,520732,912038,823143,711089,182571,464991,420134,589780,825364,583415,958931,336209,808010,307450,1006692,890295,972079,644370,766876,772733,894331,345442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]