SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312681 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312681 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486174,183586,494525,545889,154092,323084,405693,879852,944984,73956,672216,375143,474982,401983,419319,984846,67775,80057,198841,202459,173081,820155,60462,467612,597866,710707,890303,780273,525460,232804,771140,448789,863337,841792,484684,217811,220680,597589,922010,177836,204496,394810,355204,776567,292061,290697,1046012,401550,1033601,1013825,945635,814239,1038375,1047389,726747,814217,682512,896938,774642,677133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]