SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556194 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556194 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339545,607651,394870,170000,649223,280336,342799,217491,310695,18156,1001539,14071,733591,884818,290470,214608,32746,272213,249286,427719,145699,300170,176136,473154,763561,805645,278045,453666,623219,169311,166148,521289,706142,199249,881571,1031925,943148,912835,999958,836921,158356,581915,760815,158536,943777,180344,174832,197301,34613,250297,1028917,418615,755748,156275,297206,512694,230031,95282,370363,518423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]