SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550643 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550643 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328190,771272,1025499,1644,297061,536209,41782,98302,875837,784315,921724,894330,397818,350001,1047253,369551,331462,1001741,549370,36480,291634,634303,50450,117348,318745,583004,651216,658547,927437,335360,969158,829108,990146,585967,255366,969660,611291,600451,98062,551211,48328,796833,895621,410600,625167,173915,446128,1036455,648495,333358,463971,917933,727854,567699,5025,215601,706456,973805,163966,479067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]