SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467654 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467654 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346941,1024430,653069,985560,673468,716806,448745,441061,835490,619797,497465,748798,221274,575594,880473,959177,1007271,805271,577545,880214,288525,388172,140741,706697,305060,186332,410070,158895,583206,738688,208275,764935,207047,385969,578477,21188,706434,688767,906674,188289,54631,551914,174524,232884,166934,614021,1036732,853701,126553,796568,456133,142081,774557,327652,200840,154134,578969,621078,88094,641076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]