SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504582 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504582 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836826,1036773,447033,1020399,388567,1033511,436601,172681,882169,1000731,341288,915270,6456,619529,797971,553038,644213,439871,4746,73163,554447,1028685,333707,758866,262196,894783,79241,78751,476643,105626,257970,748133,611972,439796,895569,548472,340058,823997,117003,238835,651403,671159,859155,226191,143002,557659,748361,419339,782284,751309,1031164,173866,774086,815747,821418,424040,462410,1008069,74773,4288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]