SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044000 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044000 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58294,997279,313359,205792,253820,169985,987224,253635,580452,666745,68704,515064,184955,815073,673732,371689,208322,487828,962957,522277,1009905,398521,628689,641964,396812,631171,482318,229962,826889,125235,646503,8406,787983,671884,906474,554565,587488,560118,52508,504477,932743,863243,24907,358106,509448,811191,356778,643281,878941,665759,597375,396076,100435,689323,726480,908063,137131,388220,486484,336655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002779s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]