SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330624 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330624 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444049,136486,974614,1029147,569783,705377,106326,299029,100018,497860,282465,77952,481674,56598,546354,66568,942906,788642,131874,945873,1024815,73808,612717,143304,178749,157677,354409,280916,304470,992200,292541,544478,884022,469209,865292,479171,900955,233565,234955,1001701,223214,825393,185635,347755,301083,299719,150307,603577,779154,496700,1030838,111921,186088,1018887,275883,653669,431586,893107,489774,857380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330624 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330624 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]