SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308208 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308208 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002180,590771,812699,255379,121215,817222,875449,983436,230005,984530,306938,431145,502258,804880,344097,879936,981985,394515,437216,98311,906239,496336,211221,189052,826535,473165,456239,29396,1016226,761528,918670,80068,248484,376691,1047506,528884,771057,942735,111545,262518,1036371,993431,132276,723510,277638,159084,11402,299418,168352,723108,87007,162290,379764,120609,636689,576417,608351,883157,495369,971549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]