SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142104 LIMIT 1 [ RunTime:0.004026s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142104 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266805,722007,882999,499997,551951,332043,238278,778091,72128,145267,955430,270108,895404,993942,951859,402479,1011120,814642,75292,234679,1032984,871692,225571,615597,379402,585771,289119,577096,368413,421235,183550,763288,309657,296475,913541,450873,415432,546539,260866,702082,264405,404117,216819,186490,383467,568338,982782,618336,900202,1028729,35845,674835,878627,644107,647016,741401,812354,229891,925905,653510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]