SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529911 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529911 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320332,951593,379909,619946,214191,184038,173818,985754,358749,555810,574775,273247,114682,823466,497669,310521,324216,827555,344143,434212,708943,1012932,301318,295435,236332,18716,68063,215988,643529,612919,352628,859479,861475,475397,236241,790735,267876,100171,410079,672275,834268,278062,36532,378184,182551,640248,719244,406861,623861,1006254,283716,793031,1006440,951526,90985,60751,944668,890270,264062,9784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]