SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543801 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543801 [ RunTime:0.003783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191303,736235,975105,763041,66492,33734,953945,142296,345238,346162,693839,850979,895412,204208,587069,969677,143539,563917,129764,534162,54876,74866,1031487,468303,995544,224415,881857,968245,71995,628852,673205,635606,475331,905094,897973,77261,961266,787742,502602,183989,167580,660308,120587,585720,582514,610199,907173,376740,126830,585842,293241,932365,239047,450592,515665,632303,673293,885786,939085,48261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]