SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4391 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4391 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656446,893462,498281,800033,1041638,756830,46253,104263,476529,660649,309923,651019,779084,287066,37480,637316,987011,546643,417383,624721,918382,966488,527464,955921,453233,942694,1025188,525134,841811,715894,904942,201441,832472,1001695,84333,58259,430119,828966,167833,939901,620908,357193,913527,409923,933395,774054,709593,565023,456589,524963,642093,467440,268964,296668,520752,992320,607169,794432,244336,477700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]