SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531092 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531092 [ RunTime:0.003303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565671,327248,21888,1007698,1000135,209224,288480,286839,569991,871048,631820,728513,278278,949758,348871,1007938,548271,1037840,902387,780380,183958,228679,1000849,721815,113400,231994,622596,711179,784849,903843,27755,131597,948034,732060,627210,807818,59064,964456,270731,803732,341435,854275,985790,342200,546348,512434,383218,404117,832632,898240,1027370,901754,457469,735488,38234,711843,49692,108083,863956,676995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]