SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328904 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328904 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316855,1021930,596244,21963,384508,409271,679336,443007,185459,964350,380565,66731,554060,946250,802062,1023181,1041443,729446,264468,356214,666088,493286,919055,360885,366407,795613,765082,189826,118142,75863,490462,741680,12194,781779,292056,319966,598855,839883,515386,399433,940709,930354,1046420,660356,373747,928761,393976,117778,4060,557347,215574,1000764,571313,989087,309814,484009,652797,252575,101749,926045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]