SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28389 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28389 [ RunTime:0.001933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692118,401008,305996,149708,483856,779200,975098,335104,434960,632026,784961,431454,869892,62483,969475,43999,640131,902351,211881,255784,373183,448705,812214,406747,504643,558817,806645,37929,239431,650501,172100,167481,338805,930915,322946,277945,908904,646987,617344,781307,512887,628908,335092,451866,890238,253753,205132,920631,427901,765113,913571,683222,956572,74360,642993,1007610,926016,42696,509217,464821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]