SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294570 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294570 [ RunTime:0.002205s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291499,651455,470849,138971,247034,288753,863919,213789,875785,178090,501095,837752,833362,664670,976471,443034,537102,157438,973907,839146,1020777,952962,544908,611461,453165,400379,67169,76774,933194,523417,708541,42961,775212,780508,443072,31607,997634,780314,805455,758597,411038,140171,782176,52314,808459,457275,818692,807995,445126,227982,65634,144043,281370,285369,861558,859286,441489,404472,499696,956821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]