SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501782 LIMIT 1 [ RunTime:0.000609s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501782 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198185,184005,453841,298588,197331,86132,153347,595919,779566,632478,565651,660296,70573,655871,234275,64891,741420,16206,277109,233323,1001815,88518,271471,983132,988136,805048,316261,818619,17998,148415,418440,63356,630274,1020453,1015147,669722,635068,83731,963460,143006,552940,518526,119210,543420,655982,211213,1016083,306269,894242,105818,997610,645025,387777,960341,1014257,288314,509733,818704,107673,412017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501782 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501782 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001164s ]