SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405327 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405327 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403165,992434,551700,898723,347007,682448,518062,845208,739878,873329,273756,934587,968207,962842,240589,211359,278218,789620,944934,703914,20024,310403,167771,494006,947168,373221,378320,724204,933857,626392,149312,526432,159197,855387,799210,227208,264122,938992,377189,489415,912590,259179,540646,554480,16575,527970,344834,255377,955224,936111,143260,293249,68636,840826,642589,697239,382256,742532,569006,713564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]