SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471025 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471025 [ RunTime:0.002803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172757,896431,1011621,518710,301949,610766,441640,486550,733568,589944,4812,200817,453850,587591,742810,1026989,232892,511023,842069,693334,375674,682824,81474,379454,43511,217592,700426,730874,706306,97002,91050,701669,648333,461328,259548,153582,261485,235243,290300,67710,971792,468305,370744,287772,206203,912747,354346,241826,488219,866160,143025,170459,697194,520087,434408,56776,206180,310775,332047,803793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]