SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40662 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40662 [ RunTime:0.001467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241290,97220,1021517,139860,774717,494699,239479,411947,240242,285321,981692,602591,713207,338600,339995,21006,618577,946938,328516,1004306,703588,400819,765487,590972,803192,236706,540322,36567,179214,799895,954012,226666,958267,550566,302348,628838,517007,546169,72668,409686,644902,255697,205355,747498,95504,668053,382778,175987,1003216,292347,602789,104432,516246,126774,344426,5532,321388,934480,459150,271026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40662 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40662 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]