SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400055 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400055 [ RunTime:0.002627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495618,664850,745735,1024498,817740,957595,391470,911239,765147,174065,14721,1033469,529380,713203,461737,659365,57750,903809,120586,561566,132624,688511,452369,211511,395500,408871,575021,321987,571849,145275,755018,777691,843190,228728,250736,758673,900195,516532,233897,209841,551805,701463,89113,587541,239314,931455,984735,1039007,503820,495499,589761,163492,141687,379723,324864,759121,530611,449508,266129,258244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000358s ]