SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021069 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021069 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888389,499743,722040,616180,715276,448000,85197,182583,212389,714671,522352,1019104,881353,957602,651696,62092,857940,150296,567349,131903,473563,239977,22241,993883,168793,198580,862428,437879,802805,80082,287765,382026,852753,100412,955845,595217,160658,812935,521652,516590,719619,271772,914362,408458,891004,824583,635975,885490,156613,834075,22972,817953,205401,626575,649027,797868,964555,866187,792608,464874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]