SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505443 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505443 [ RunTime:0.002864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600,859898,248225,95304,290189,785237,259896,944374,894964,95487,33783,263000,34129,648207,549155,192789,1017955,946719,180960,652720,117988,794272,168439,874286,690241,7431,557109,924891,15255,1045661,726740,1021142,548844,612092,805396,394439,790025,156434,523133,228624,486871,92704,805606,398847,927377,110650,456901,453754,495076,326560,507939,733085,976938,475855,875561,957637,554451,443088,166761,917508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]