SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318896 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318896 [ RunTime:0.002109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545729,610771,682888,124744,591387,436714,146651,218144,666034,350603,665801,1036338,851161,138323,372500,983518,689965,58851,286013,360464,1025465,98791,432854,655319,485053,32439,290589,973379,274494,97290,701622,918913,678046,373107,418401,732973,965774,709982,62216,342971,295400,703083,682774,221227,323136,527618,930289,301610,533734,977494,720455,72087,887952,64692,341624,161867,181337,59567,1037724,211568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000852s ]