SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495912 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495912 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639325,254160,786096,353763,251926,825546,788449,1027652,347985,862189,345685,579558,861275,469837,63470,498166,784838,828025,909511,553405,944497,999229,414010,322325,855042,283357,836760,896425,121775,450545,146308,151458,132586,637786,708859,254557,236562,734953,449332,273774,334173,643281,1040379,32492,855261,102577,671143,184576,347896,626091,249786,904423,325746,131228,58301,857015,166860,714276,633881,97865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]