SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027008 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027008 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68970,249704,791749,401724,615846,891638,906428,633650,806989,546944,474464,71499,267585,986201,282670,241067,740484,189174,575419,1036101,1036993,420036,317704,697757,888386,259959,1020112,372188,281587,974768,130222,520414,827259,441481,962956,609138,792361,8342,916281,82828,248930,767862,326976,247189,453404,666374,120812,738560,281682,545576,614721,290796,812672,422061,130813,314839,433511,565341,887187,884057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]