SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491083 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491083 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464596,689695,401514,409826,504117,41770,23041,479815,516368,986230,315118,134104,1034327,58532,289421,253219,373662,994654,267822,846226,196101,6846,249920,63130,404122,722574,848238,720682,951147,9190,1043832,367692,991599,702072,523513,1021031,25502,272397,386630,832232,667339,525667,717566,573788,442644,13199,18477,1007365,50756,726064,74695,246052,69972,1015471,278363,72175,610270,38748,989192,205869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]