SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 212808 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 212808 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445603,707794,323900,517919,195558,233266,929509,65673,757744,592070,916567,900900,936886,983254,1018132,219802,1038499,309065,292972,207628,421764,497894,792816,950997,674373,171999,737783,580625,478281,348577,1027745,712608,1009684,288147,703401,740989,52375,391014,556170,44927,542721,462384,511958,299012,160175,315771,1038894,204847,666094,944281,992103,443495,378842,81841,889080,699936,210568,929821,254509,816125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 212808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 212808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]