SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294701 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294701 [ RunTime:0.002190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240693,931858,874879,876692,937854,807691,1041443,406858,552407,929986,301930,142507,67347,645017,829260,168701,62471,692101,501062,660469,391339,22933,984113,843598,476201,527570,968137,695919,976642,532647,99166,17171,271244,729101,153888,441877,171202,808226,164110,1003709,867754,255576,600237,75043,946924,944083,357746,987815,503764,806937,490171,682691,648081,11928,19452,122648,629298,1044695,865499,86298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001265s ]