SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103432 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103432 [ RunTime:0.005285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813360,748690,136571,187386,980986,861378,320072,314060,556849,254848,1323,308943,191082,713314,547807,922432,498946,881459,595678,997471,459865,396202,491110,782377,1001802,251629,298218,453351,583362,676442,1047790,542987,689121,810130,361377,375355,48179,612972,755445,848133,213978,711031,808586,582022,985242,250629,549791,986194,455520,875224,880554,407959,103510,667527,463224,208277,842594,62900,509812,24257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]