SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348094 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348094 [ RunTime:0.002834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349050,48690,206766,600553,936328,814811,666625,660661,631767,237244,292929,491892,754138,180573,78660,253274,552355,252310,102155,451749,20128,215555,526515,610517,899462,122090,955584,426901,75400,1009871,749024,198947,461159,383092,912250,201,794114,309509,505738,311573,455547,309184,220592,57152,933547,282609,588089,81687,728681,768444,686652,520453,905179,129159,409448,44094,583718,672847,819246,849891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]