SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561981 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561981 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739619,381988,1032808,129921,736655,190088,245769,484612,630370,729102,215018,510368,382363,826315,294304,502592,188945,222901,580873,520593,626488,1019572,864805,424420,1043146,50230,255742,139212,283650,806426,748591,886054,519171,684103,437190,530,924623,688012,205972,741582,258338,440580,56989,510630,623606,282562,416232,903725,895963,53975,317488,415625,568686,540935,805399,544080,280289,948766,455274,11218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]