SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453943 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453943 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123006,404316,192214,383684,118595,383657,493571,85561,719756,838809,986157,207261,190534,45148,810255,911364,979279,498809,103620,136765,505958,143157,596370,961692,945739,447550,1021722,347298,780974,332950,775129,695956,779382,466580,553882,685349,597940,792645,1010953,472495,827607,883044,140317,863473,696853,701762,340905,780067,893861,763281,303153,331780,236083,289843,69067,473388,893573,882857,895555,874546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]