SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043187 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043187 [ RunTime:0.002640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43815,164024,120407,264392,940623,520981,659544,1023943,1017634,363293,218401,68497,190666,174075,678919,159191,840693,595689,323533,698695,66615,405920,822409,369645,131134,810391,1042008,371931,507124,354273,1040858,694886,575955,227653,1010079,45755,936009,539779,587410,861196,290162,217763,51739,66460,1028914,412878,761581,649212,13443,735921,44224,168100,235418,974208,722427,315107,1024293,81579,603659,457908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001430s ]