SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38195 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38195 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037717,317662,480640,228639,638643,478557,153418,566165,357484,381585,1018573,824130,757368,220029,137079,498438,92062,864558,824655,534585,128210,224194,236663,625214,1027027,375685,988818,236227,1018135,347606,320457,205871,532180,497325,981834,797676,541892,579585,632469,167611,113770,283386,960574,929925,274386,253810,318589,372862,62541,240879,38443,289785,689969,87518,37854,409506,756445,414834,238391,354163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]