SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437409 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437409 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992197,477243,868034,387602,835442,972260,58260,871260,810091,716628,400035,346241,979165,256051,276174,679425,64537,754263,869609,351416,737586,432603,10594,292995,15232,592126,1028367,598099,294517,1037681,377813,1038086,17615,714587,788565,23196,481394,60812,831993,366538,581359,868367,562028,442969,237877,259912,397442,135322,431849,850571,299987,198766,396767,548194,716466,1002948,217653,746076,54561,311823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]