SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 603909 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 603909 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783003,954414,86142,523362,822566,661347,349972,812888,8146,464162,1047279,892799,380939,143541,1002418,958112,648488,925106,62276,201185,46946,878573,39722,974492,1025012,320018,859938,843355,908474,402919,469791,652637,21168,199983,582253,958191,534158,310188,151473,57901,9597,933978,464924,330445,262848,909206,978209,88941,788751,396228,111283,181203,86772,422734,814564,1770,56336,403677,658880,770703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 603909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 603909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]