SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580571 LIMIT 1 [ RunTime:0.001742s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580571 [ RunTime:0.009044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769406,464916,1010093,858507,173683,354309,1013045,3976,431167,521138,114200,408375,356789,975112,212581,1013884,20956,172617,122566,642471,56466,710467,651529,930646,746643,610658,958790,620441,32197,342207,543673,80255,687810,250928,615897,801966,510805,52053,878927,157412,380463,780327,94837,362147,801900,562239,174674,16868,748276,312217,301680,53771,741421,25621,12073,388340,461153,1027769,499957,432679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003171s ]