SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 704210 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 704210 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498847,214785,110333,216053,499400,491361,122112,125489,200601,1039045,868531,579070,814215,785428,911442,132685,525981,1013502,736794,173780,114991,351989,568097,1000324,1011245,965005,811322,995411,686662,996715,349700,346597,618431,466992,709853,741634,164429,234348,802032,160365,842306,796350,300719,172286,131848,966860,294219,673969,139939,930385,153624,122299,12028,244562,991156,640953,731781,831526,406002,793971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 704210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 704210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]