SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478956 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478956 [ RunTime:0.004534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662031,133665,129171,37530,673256,174216,1038293,134432,983069,352816,839142,54749,412729,127134,278730,311328,489232,589848,154914,532488,532765,986792,1038774,448792,39280,486722,725883,371517,697891,98249,401760,314007,705812,933091,932738,159665,15407,341910,522726,196690,1035503,792933,912703,247149,257630,687554,393846,1034472,341400,331544,670552,369489,1003100,687762,780951,516144,169542,648830,971913,727249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]