SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118410 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118410 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172568,110904,232335,220520,458905,232887,162216,338868,562506,81157,1028610,579537,328581,106509,280592,832777,482955,254431,336350,134342,872458,264531,940111,23253,495925,283440,19300,1003417,991860,819262,306375,485722,440247,779337,95204,491480,834321,26949,985506,345835,315733,409899,436388,633315,804504,890993,585867,281401,740553,273199,485460,383340,289926,849376,620106,330234,487024,776076,439700,211228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]