SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511510 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511510 [ RunTime:0.002966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981027,851544,83702,23871,76108,895147,738401,206161,318930,428208,170038,196207,1029568,1006824,480345,765540,95222,226434,495141,807360,2185,1028938,380497,522407,666470,1030026,1033229,196545,857597,394159,1046916,1025745,821118,1042580,367694,376262,480381,672910,567305,312024,70637,185173,274997,71183,292856,8777,364938,27863,69654,78504,44213,982244,292712,829999,996202,979515,663917,792504,816285,235936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]