SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802561 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802561 [ RunTime:0.003021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135181,40651,220184,394334,597020,17805,276397,334289,972376,800561,151926,566632,300177,191329,186649,692794,282637,718401,1042108,933835,167563,956081,656978,57818,618549,722009,409523,219952,538356,209692,14432,197000,1000434,374517,859992,769109,598129,858087,725798,7928,410329,879110,812230,218654,22666,855453,550050,228776,209481,891342,1042638,134468,958181,109971,572889,63531,575830,1004195,571023,257907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001885s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]