SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001820s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474984 LIMIT 1 [ RunTime:0.001401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474984 [ RunTime:0.002955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742268,547385,321749,556751,307160,462291,325670,96445,611837,176564,537447,404834,97489,145105,59860,808534,382280,513569,851651,1009119,289931,624410,449237,742842,878078,998236,985938,178814,430890,417364,441286,228826,302793,394800,836903,410505,780024,454977,377800,590434,918265,977199,1021839,402241,762869,121837,599354,833003,218567,443683,221851,1014092,638562,897241,877318,1010326,490499,749191,437544,789366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]