SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401118 LIMIT 1 [ RunTime:0.000583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401118 [ RunTime:0.002419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101932,63045,223410,672898,360441,1014717,319302,895300,370457,768026,55351,298423,561824,407645,423525,275708,469833,573380,343052,544680,1034140,876316,393004,41402,1032345,815146,991452,878287,901575,248818,689821,730076,504664,43293,798136,274395,80007,606741,624923,956570,476689,215266,539456,672302,783949,177710,836906,1041432,874227,876112,623283,141812,665224,956104,45394,757727,243725,100535,156211,548081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001753s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]