SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269743 LIMIT 1 [ RunTime:0.000506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269743 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912153,193199,564879,287987,819477,428844,450264,990723,289557,350098,807095,714954,604918,98096,359014,983409,1041931,783399,21375,138347,493320,521891,149553,757610,349564,387080,920470,100241,581936,656037,249105,456924,12914,37890,872839,972133,257971,234907,410954,795754,582335,864535,152248,434953,124982,465442,607315,459059,530547,616816,988924,262982,734675,152589,355178,483160,592403,216187,1033086,262309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]