SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542241 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542241 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560749,361418,101696,434469,654226,545789,509660,868792,667713,195093,248885,701890,21382,373066,291922,1001313,493266,274404,1014653,432868,621052,861010,843752,346985,980266,561060,927162,238040,535143,893228,520819,741038,12844,466177,890969,146717,769700,319437,975691,552708,834355,625166,748412,365658,252482,900800,693500,237247,6288,1037884,197782,356333,6021,623293,203015,184302,304646,512473,609580,386201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]