SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555046 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555046 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255211,303801,541204,797620,843361,943490,1039162,373314,523158,880042,362175,1000334,767140,896841,1029350,474227,665027,920001,910620,1009528,544521,958815,751686,237555,444948,1001996,259087,194496,10905,55586,343545,27230,666157,1005362,458175,859277,139607,408206,237912,70455,848395,384627,422652,176678,488643,260750,571133,43722,440652,337761,779238,389576,793280,747799,79809,1034773,170330,870406,440050,237654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002601s ]