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` = 354041 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354041 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443489,787631,48198,342132,474552,76617,408966,855100,502222,576446,383010,786291,91002,115812,524151,11473,48811,490565,230146,903889,715738,538451,52552,332865,158326,591290,510245,609913,946546,927960,743191,805147,960458,296125,24238,142957,586713,163091,130770,266648,538301,917718,134017,988782,489747,971452,92684,583156,329138,1025519,145034,678521,753828,850893,539420,470936,1011120,565435,806470,969003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]