SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 657540 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 657540 [ RunTime:0.002799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029106,78811,1009227,442504,204840,881632,735847,941728,119331,331683,612896,691374,265922,752004,365469,220419,342431,623574,497248,257006,424824,908920,950043,808119,797910,83543,258563,984745,759505,877653,1012592,429354,367145,771346,824888,1039065,990778,17686,396018,332142,1010646,480527,876644,817500,772180,173036,501083,511957,745076,30054,185674,493249,18001,129227,741043,423563,408242,626526,822288,839390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 657540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 657540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001139s ]