SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402515 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402515 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285205,812694,920194,902255,244824,362002,930336,190989,882873,874528,417976,1035022,63070,546170,704938,97818,948631,654464,550653,201743,619515,156329,548864,749410,357166,956901,212189,31955,854553,849262,735054,801999,428823,695728,754450,252570,208845,722228,916661,695319,107715,759314,996021,1043527,299674,15043,874025,635582,179156,816730,811150,852602,250714,1043818,470784,824480,941570,8917,681578,789910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]