SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455440 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455440 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237048,457492,718376,461140,240557,738470,380915,479814,558211,12592,803360,1004163,749349,3271,237027,282738,954232,693361,730463,329298,752518,956001,80707,107011,291230,213685,439133,987133,775624,326605,249876,270644,133354,147857,800811,525379,373435,317302,671685,454699,56612,563460,8426,848924,144443,796623,1045965,367708,902896,180698,240191,769899,1024192,992892,374804,6149,620304,652022,256863,797408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001921s ]