SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263443 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263443 [ RunTime:0.003971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026464,443878,583950,196676,528837,805521,150458,971940,292050,280443,191780,936811,573983,278850,126439,241976,488103,373153,421319,208228,982680,703487,459186,982567,675003,965865,955104,354753,778345,889074,454729,613150,125682,853407,736499,492249,502431,723271,391729,292897,667268,668615,252958,88653,213988,903574,1701,875244,705463,531537,978292,218969,985944,507772,108110,788083,1017803,702858,929395,308740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001092s ]