SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508910 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508910 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222357,296773,457596,999611,460840,245975,716057,117284,643649,133705,426961,86358,585924,509506,75148,725478,33053,82259,34906,702035,519145,29899,274177,990048,151657,586454,641834,468141,30386,1042025,474365,469305,945289,628196,794058,14015,291060,1024804,718242,66879,750727,942898,212165,464380,881506,435003,158010,516131,106326,1002291,1048572,425207,295965,491321,971184,195752,348297,172965,1001004,794613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]