SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510071 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510071 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720904,747011,491481,47730,366186,419221,685797,79208,784161,385278,994580,278395,262506,790193,735863,802793,545768,623425,341377,645035,6861,37694,3773,766173,189689,974035,417387,971785,1019219,686934,381651,180363,197726,916707,116743,929180,1028323,246461,466360,112850,674072,440431,950825,410785,464880,195074,992086,778361,158187,905365,894177,834359,317050,244514,581460,654143,795349,744019,822843,578168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]