SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586911 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586911 [ RunTime:0.002325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946133,260756,1039993,996415,333816,757447,989305,3987,248963,863316,749540,305131,165917,328303,548140,810638,925576,776649,1008724,1010,632674,280892,91875,106112,818072,811561,373897,510917,907163,874096,836523,683045,405050,553872,568313,465784,51437,683516,137468,297769,510415,850130,895467,1041462,139447,755052,506591,39505,626699,353181,546533,398238,230480,697876,38287,15868,907908,637138,677977,277575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]