SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 270913 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 270913 [ RunTime:0.008790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366786,467,1038700,320306,509211,965080,715066,88020,179854,9216,582716,239374,497078,544122,897890,131796,597372,395630,1111,421559,448809,122219,819978,182050,47523,878105,928847,340448,872852,592622,979673,87706,346502,128356,516280,232689,109520,860016,188493,717083,674329,612326,769567,355200,838010,892441,934824,374487,706553,907879,950042,486268,374319,166049,901058,321735,231547,501135,910338,251288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 270913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 270913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000741s ]